Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_SERVER_REGISTRY

`DBA_SERVER_REGISTRY` displays information about the components loaded into the database.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`COMP_ID` | `VARCHAR2(30)` | `NOT NULL` | Component identifier
`COMP_NAME` | `VARCHAR2(255)` |  | Component name
`VERSION` | `VARCHAR2(30)` |  | Component version loaded
`STATUS` | `VARCHAR2(11)` |  | Component status: `INVALID` `VALID` `LOADING` `LOADED` `UPGRADING` `UPGRADED` `DOWNGRADING` `DOWNGRADED` `REMOVING` `REMOVED`
`MODIFIED` | `VARCHAR2(20)` |  | Time when the component was last modified
`CONTROL` | `VARCHAR2(30)` | `NOT NULL` | User that created the component entry
`SCHEMA` | `VARCHAR2(30)` | `NOT NULL` | User that contains the objects for the component
`PROCEDURE` | `VARCHAR2(61)` |  | Validation procedure
`STARTUP` | `VARCHAR2(8)` |  | Indicates whether the component requires a startup after the upgrade (`REQUIRED`) or not
`PARENT_ID` | `VARCHAR2(30)` |  | Parent component identifier